{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Final Fin. Report","Summary of Estimated Costs","Summary of Est. Costs"],"not_rendered":{"external_links":2,"defined_names":3},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Final Fin. Report","index":0,"n_rows":74,"n_cols":18,"rows_kept":74,"merged":[[3,1,3,4],[3,5,3,9],[72,0,72,10]],"flags":["formulas_cached_only"]}
[" ","Contract No DEVPOL/2014/355-113"]
[null,"Implementation period of the contract (24/12/2014-31/03/2016)"]
[]
["Final financial report:                                        period (24/12/2014-31/03/2016)","Budget as per contract in EUR",{"$nulls":3},"Expenditure incurred in USD*",{"$nulls":4},"Expenditure incurred in EUR",{"$nulls":4},"Variations in comparison with initial budget"]
["Expenditures","Unit","# Units","Unit value\n(in EUR)","Total Cost\n(in EUR)","# Units","Unit value\n(in USD)","Total Cost\n(in USD)","Cumulated costs (before current report) (in USD)","Cumulated costs (from start of implementation to present report included) (in USD)","# Units","Unit value\n(in EUR)","Total Cost\n(in EUR)","Cumulated costs (before current report) (in EUR)","Cumulated costs (from start of implementation to present report included) (in EUR)","In absolute value in EUR","In %","Explanation for all variations"]
["Result 1.1-Africa Regional Monitoring Workshop",null,"(a)","(b)","(c)=a*b","(a)","(b)","(c)=a*b","(d)","(f)=c+d","(a)","(b)","(c)=a*b","(d)","(f)=c+d"]
["1. Human Resources"]
["Regional/subregional workshop (Africa)-10 working days Administrative/Support  consultant fee","Daily",10,100,{"v":1000,"d":"1,000.00"},10,{"v":149.93804213135067,"d":"150"},{"v":1499.3804213135068,"d":"1,499"},0,{"v":1499.3804213135068,"d":"1,499.38"},10,{"v":121,"d":"121.00"},{"v":1210,"d":"1,210"},0,{"v":1210,"d":"1,210"},-210,{"v":0.21,"d":"21%"},"Daily fee for admin/support cons. was 150 USD (121 EUR)"]
["Regional/subregional workshop (Africa)-15 working days technical consultant fee","Daily",15,420,{"v":6300,"d":"6,300"},15,{"v":517.9677819083023,"d":"518"},{"v":7769.516728624534,"d":"7,770"},0,{"v":7769.516728624534,"d":"7,770"},15,{"v":418,"d":"418.00"},{"v":6270,"d":"6,270"},0,{"v":6270,"d":"6,270"},30,{"v":-0.004761904761904762,"d":"-0%"}]
["On-site support to regional/sub regional workshop (Africa) staff and consultant for 5 working days+travel and communication staff for 3 days+travel","DSA",16,157,{"v":2512,"d":"2,512"},16,{"v":206.93928128872366,"d":"207"},{"v":3311.0285006195786,"d":"3,311"},0,{"v":3311.0285006195786,"d":"3,311"},16,{"v":167,"d":"167.00"},{"v":2672,"d":"2,672"},0,{"v":2672,"d":"2,672"},-160,{"v":0.06369426751592357,"d":"6%"}]
["Regional/subregional workshop (Africa-TBC) -DSA for 60 participants (3 days+travel day)-Addis Ababa DSA rates of E 157/day","DSA",180,157,{"v":28260,"d":"28,260"},189,{"v":206.93928128872366,"d":"207"},{"v":39111.52416356877,"d":"39,112"},null,{"v":39111.52416356877,"d":"39,112"},189,{"v":167,"d":"167.00"},{"v":31563,"d":"31,563"},0,{"v":31563,"d":"31,563"},{"v":-3303,"d":"-3,303"},{"v":0.11687898089171975,"d":"12%"},"DSA for Addis Ababa in November 2015 was 167 EUR. Participants were 63"]
["Subtotal Human Resources- Result 1.1",{"$nulls":3},{"v":38072,"d":"38,072"},null,null,{"v":51691.44981412639,"d":"51,691"},0,{"v":51691.44981412639,"d":"51,691"},null,null,{"v":41715,"d":"41,715"},0,{"v":41715,"d":"41,715"},{"v":-3643,"d":"-3,643"},{"v":0.09568711914267704,"d":"10%"}]
["2. Travel"]
["2.1. International travel"]
["Regional/subregional workshop (Africa-TBC) Travel for 60 participants ","Per Flight",60,{"v":1000,"d":"1,000"},{"v":60000,"d":"60,000"},63,{"v":1218.091697645601,"d":"1,218"},{"v":76739.77695167286,"d":"76,740"},0,{"v":76739.77695167286,"d":"76,740"},63,{"v":983,"d":"983.00"},{"v":61929,"d":"61,929"},0,{"v":61929,"d":"61,929"},{"v":-1929,"d":"-1,929"},{"v":0.03215,"d":"3%"},"Participants were 63 "]
["On-site support to regional monitoring workshop regional staff, support consultant and communication staff","Per Flight",3,{"v":1000,"d":"1,000"},{"v":3000,"d":"3,000"},3,{"v":1210.6567534076828,"d":"1,211"},{"v":3631.970260223048,"d":"3,632"},0,{"v":3631.970260223048,"d":"3,632"},3,{"v":977,"d":"977.00"},{"v":2931,"d":"2,931"},0,{"v":2931,"d":"2,931"},69,{"v":-0.023,"d":"-2%"}]
["2.2 Local transportation "]
["Local transportation provided for participants in country",null,null,{"v":3500,"d":"3,500"},{"v":3500,"d":"3,500"},null,{"v":4151.177199504336,"d":"4,151"},{"v":4151.177199504336,"d":"4,151"},0,{"v":4151.177199504336,"d":"4,151"},null,{"v":3350,"d":"3,350.00"},{"v":3350,"d":"3,350"},0,{"v":3350,"d":"3,350"},150,{"v":-0.04285714285714286,"d":"-4%"}]
["Subtotal Travel- Result 1.1",{"$nulls":3},{"v":66500,"d":"66,500"},null,null,{"v":84522.92441140025,"d":"84,523"},0,{"v":84522.92441140025,"d":"84,523"},null,null,{"v":68210,"d":"68,210"},null,{"v":68210,"d":"68,210"},{"v":-1710,"d":"-1,710"},{"v":0.025714285714285714,"d":"3%"}]
["3. Equipment and supplies"]
["Banner for the workshop",{"$nulls":3},{"v":1000,"d":"1,000"},null,null,{"v":1223.0483271375465,"d":"1,223"},0,{"v":1223.0483271375465,"d":"1,223"},null,null,987,0,987,13,{"v":-0.013,"d":"-1%"}]
["Subtotal Equipment and supplies- Result 1.1",{"$nulls":3},{"v":1000,"d":"1,000"},null,null,{"v":1223.0483271375465,"d":"1,223"},0,{"v":1223.0483271375465,"d":"1,223"},null,null,987,0,987,13,{"v":-0.013,"d":"-1%"}]
["4. Local office"]
["Regional/subregional workshop (Africa-TBC) Facility/Venue Rental","Per participant",90,66,{"v":5940,"d":"5,940"},90,{"v":83.02354399008674,"d":"83"},{"v":7472.118959107806,"d":"7,472"},0,{"v":7472.118959107806,"d":"7,472"},90,67,{"v":6030,"d":"6,030"},0,{"v":6030,"d":"6,030"},-90,{"v":0.015151515151515152,"d":"2%"}]
["Subtotal Local office Result ",{"$nulls":3},{"v":5940,"d":"5,940"},null,null,{"v":7472.118959107806,"d":"7,472"},0,{"v":7472.118959107806,"d":"7,472"},null,null,{"v":6030,"d":"6,030"},0,{"v":6030,"d":"6,030"},-90,{"v":0.015151515151515152,"d":"2%"}]
["5. Other costs, services"]
["5.5 Translation, interpreters- for Regional/Sub-regional Workshop (Africa-TBC) 3 interpreters at 3 days","Per day",9,600,{"v":5400,"d":"5,400"},9,{"v":619.5786864931846,"d":"620"},{"v":5576.208178438661,"d":"5,576"},0,{"v":5576.208178438661,"d":"5,576"},9,500,{"v":4500,"d":"4,500"},0,{"v":4500,"d":"4,500"},900,{"v":-0.16666666666666666,"d":"-17%"}]
["Subtotal Other costs, services- Result ",{"$nulls":3},{"v":5400,"d":"5,400"},null,null,{"v":5576.208178438661,"d":"5,576"},0,{"v":5576.208178438661,"d":"5,576"},null,null,{"v":4500,"d":"4,500"},0,{"v":4500,"d":"4,500"},900,{"v":-0.16666666666666666,"d":"-17%"}]
["Sub-Total  Result 1.1- Africa Regional Monitoring Workshop",{"$nulls":3},{"v":116912,"d":"116,912"},null,null,{"v":150485.74969021065,"d":"150,486"},0,{"v":150485.74969021065,"d":"150,486"},null,null,{"v":121442,"d":"121,442"},0,{"v":121442,"d":"121,442"},{"v":-4530,"d":"-4,530"},{"v":0.03874709182975229,"d":"4%"}]
[]
["Result 1.2-Broader and strenthened country participation to the Asia-Pacific workshop on Development  Effectiveness"]
["1. Human Resources"]
[" Asia-Pacific workshop- ( Manilla March 2015)- DSA for 30 Participants (3 days+travel day)-Manila DSA rates od Euro 187/day","DSA",90,187,{"v":16830,"d":"16,830"},96,{"v":234.2007434944238,"d":"234"},{"v":22483.271375464683,"d":"22,483"},0,{"v":22483.271375464683,"d":"22,483"},96,189,{"v":18144,"d":"18,144"},0,{"v":18144,"d":"18,144"},{"v":-1314,"d":"-1,314"},{"v":0.07807486631016043,"d":"8%"},"DSA for Manila in March 2015 was 189 EUR. Participants were 32"]
["Subtotal Human Resources- Result 1.2",{"$nulls":3},{"v":16830,"d":"16,830"},null,null,{"v":22483.271375464683,"d":"22,483"},0,{"v":22483.271375464683,"d":"22,483"},null,null,{"v":18144,"d":"18,144"},0,{"v":18144,"d":"18,144"},{"v":-1314,"d":"-1,314"},{"v":0.07807486631016043,"d":"8%"}]
["2. Travel"]
["2.1. International travel"]
[" Asia-Pacific workshop- (Manilla March 2015)- travel for 30 Participants ","Per Flight ",30,{"v":1000,"d":"1,000"},{"v":30000,"d":"30,000"},33,{"v":1180.91697645601,"d":"1,181"},{"v":38970.260223048324,"d":"38,970"},0,{"v":38970.260223048324,"d":"38,970"},33,953,{"v":31449,"d":"31,449"},0,{"v":31449,"d":"31,449"},{"v":-1449,"d":"-1,449"},{"v":0.0483,"d":"5%"},"Participants were 32"]
["Subtotal Travel- Result 1.2",{"$nulls":3},{"v":30000,"d":"30,000"},null,null,{"v":38970.260223048324,"d":"38,970"},0,{"v":38970.260223048324,"d":"38,970"},null,null,{"v":31449,"d":"31,449"},null,{"v":31449,"d":"31,449"},{"v":-1449,"d":"-1,449"},{"v":0.0483,"d":"5%"}]
["Sub-Total -Result 1.2-Broader and strenthened country participation to the Asia-Pacific workshop on Development  Effectiveness",{"$nulls":3},{"v":46830,"d":"46,830"},null,null,{"v":61453.53159851301,"d":"61,454"},0,{"v":61453.53159851301,"d":"61,454"},null,null,{"v":49593,"d":"49,593"},0,{"v":49593,"d":"49,593"},{"v":-2763,"d":"-2,763"},{"v":0.05900064061499039,"d":"6%"}]
[]
["Result 1.3- Country Pilots"]
["1. Human Resources"]
["Country Pilot 1-cote d'Ivore- 15 working days+ weekends and travel","DSA",23,196,{"v":4508,"d":"4,508"},12,{"v":199.50433705080545,"d":"200"},{"v":2394.0520446096652,"d":"2,394"},0,{"v":2394.0520446096652,"d":"2,394"},12,161,{"v":1932,"d":"1,932"},0,{"v":1932,"d":"1,932"},{"v":2576,"d":"2,576"},{"v":-0.5714285714285714,"d":"-57%"},"DSA for Cote d' Ivore was 161 EUR in March 2016  and two consultants woked for one week"]
["Country Pilot 2-Asian Country (Myamar)- 15 working days+ weekends and travel","DSA",23,187,{"v":4301,"d":"4,301"},6,{"v":193.3085501858736,"d":"193"},{"v":1159.8513011152415,"d":"1,160"},0,{"v":1159.8513011152415,"d":"1,160"},6,156,936,0,936,{"v":3365,"d":"3,365"},{"v":-0.7823761915833527,"d":"-78%"},"DSA for Myanmar was  156 EUR in October 2016 one consultant worked for one week instead of two consultants"]
["Country Pilot 3-Gambia- 15 working days+ weekends and travel","DSA",23,253,{"v":5819,"d":"5,819"},15,{"v":400.24783147459726,"d":"400"},{"v":6003.7174721189585,"d":"6,004"},0,{"v":6003.7174721189585,"d":"6,004"},15,323,{"v":4845,"d":"4,845"},0,{"v":4845,"d":"4,845"},974,{"v":-0.16738271180615227,"d":"-17%"},"The mission did not took place. Th resources were reprogrammed  for consutnacy in consultation with EU expert. One consultans was hired for 15 days with dayly rate 323 EUR per day"]
["Subtotal Human Resources- Result 1.3",{"$nulls":3},{"v":14628,"d":"14,628"},null,null,{"v":9557.620817843865,"d":"9,558"},0,{"v":9557.620817843865,"d":"9,558"},null,null,{"v":7713,"d":"7,713"},0,{"v":7713,"d":"7,713"},{"v":6915,"d":"6,915"},{"v":-0.47272354388843313,"d":"-47%"}]
["2. Travel"]
["Country Pilot 1-Cote d'Ivore (travel to/from HQ)","Per Flight",1,{"v":1200,"d":"1,200"},{"v":1200,"d":"1,200"},2,{"v":1183.3952912019827,"d":"1,183"},{"v":2366.7905824039653,"d":"2,367"},0,{"v":2366.7905824039653,"d":"2,367"},2,955,{"v":1910,"d":"1,910"},0,{"v":1910,"d":"1,910"},-710,{"v":0.5916666666666667,"d":"59%"},"flights of 2 consultants"]
["Country Pilot 2-Asian Country (TBC) (travel to/from HQ)","Per Flight",1,{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},1,{"v":1112.7633209417595,"d":"1,113"},{"v":1112.7633209417595,"d":"1,113"},0,{"v":1112.7633209417595,"d":"1,113"},1,898,898,0,898,102,{"v":-0.102,"d":"-10%"}]
["Country Pilot 3-Gambia(travel to/from HQ)","Per Flight",1,{"v":1300,"d":"1,300"},{"v":1300,"d":"1,300"},0,0,0,0,0,0,0,0,0,0,{"v":1300,"d":"1,300"},{"v":-1,"d":"-100%"},"No flight took place. See the comment above"]
["Subtotal Travel- Result 1.3",{"$nulls":3},{"v":3500,"d":"3,500"},null,null,{"v":3479.553903345725,"d":"3,480"},0,{"v":3479.553903345725,"d":"3,480"},null,null,{"v":2808,"d":"2,808"},0,{"v":2808,"d":"2,808"},692,{"v":-0.1977142857142857,"d":"-20%"}]
["5. Other costs, services"]
["5.1 Publications (preparation of country pilots leaflet)",{"$nulls":3},{"v":5046,"d":"5,046"},null,null,{"v":6265.179677819083,"d":"6,265"},0,{"v":6265.179677819083,"d":"6,265"},null,null,{"v":5056,"d":"5,056"},0,{"v":5056,"d":"5,056"},-10,{"v":0.0019817677368212444,"d":"0%"}]
["Subtotal Other costs, services- Result 1.3",{"$nulls":3},{"v":5046,"d":"5,046"},null,null,{"v":6265.179677819083,"d":"6,265"},null,{"v":6265.179677819083,"d":"6,265"},null,null,{"v":5056,"d":"5,056"},0,{"v":5056,"d":"5,056"},-10,{"v":0.0019817677368212444,"d":"0%"}]
["Sub-Total -Result 1.3-Country Pilots",{"$nulls":3},{"v":23174,"d":"23,174"},null,null,{"v":19302.354399008673,"d":"19,302"},0,{"v":19302.354399008673,"d":"19,302"},null,null,{"v":15577,"d":"15,577"},0,{"v":15577,"d":"15,577"},{"v":7597,"d":"7,597"},{"v":-0.3278242858375766,"d":"-33%"}]
[]
["7.  Subtotal direct eligible costs of the Action (1-6) ",{"$nulls":3},{"v":186916,"d":"186,916"},null,null,{"v":231241.6356877323,"d":"231,242"},0,{"v":231241.6356877323,"d":"231,242"},null,null,{"v":186612,"d":"186,612"},0,{"v":186612,"d":"186,612"},304]
["8. Indirect costs (maximum 7% of  7, subtotal of direct eligible costs of the Action)",{"$nulls":3},{"v":13084,"d":"13,084"},null,null,{"v":16186.914498141268,"d":"16,187"},0,{"v":16186.914498141268,"d":"16,187"},null,null,{"v":13062.840000000026,"d":"13,063"},0,{"v":13062.840000000026,"d":"13,063"},{"v":21.15999999997439,"d":"21"},{"v":-0.0016172424335046155,"d":"-0%"}]
["9. Total eligible costs of the Action (7+ 8)"]
["10. provision of contingency reserve ( maximum 5% of 7, subtotal of dirct eligible costst of the Action"]
["11. Total eligible costs (9+10) ",{"$nulls":3},{"v":200000,"d":"200,000"},null,null,{"v":247428.55018587358,"d":"247,429"},null,{"v":247428.55018587358,"d":"247,429"},null,null,{"v":199674.84000000003,"d":"199,675"},0,{"v":199674.84000000003,"d":"199,675"},{"v":325.1599999999744,"d":"325"},{"v":-0.001625799999999872,"d":"-0%"}]
["12. - Taxes\n      - Contributions in kind",{"$nulls":3},0]
["13. Total accepted costs of the action (11+12)",{"$nulls":3},{"v":200000,"d":"200,000"},null,null,{"v":247428.55018587358,"d":"247,429"},null,{"v":247428.55018587358,"d":"247,429"},null,null,{"v":199674.84000000003,"d":"199,675"},0,{"v":199674.84000000003,"d":"199,675"},{"v":325.1599999999744,"d":"325"},{"v":-0.001625799999999872,"d":"-0%"}]
[]
["Total EU contribution:",{"v":200000,"d":"200,000"},"EUR"]
["Pre-financing payment:",{"v":160000,"d":"160,000"},"EUR"]
["Total expenditures:",{"v":199675,"d":"199,675"},"EUR"]
["Balance of the final amount of the grant:",325,"EUR"]
["To be reimbursed by EU",{"v":39675,"d":"39,675"},"EUR"]
[]
["*Exchange rate, as per United Nations Operational Rates of Exchange (UNORE), of  23/12/2014 was used 0.807"]
[]
[]
["Of the EUR 199,675 presented above, EUR 199,675 corresponds to eligible expenses and there are no legal commitments currently in force between UNDP and a third."]

{"sheet":"Summary of Estimated Costs","index":1,"n_rows":32,"n_cols":4,"rows_kept":32,"flags":["formulas_cached_only"]}
["Expected sources of funding & summary of estimated costs"]
[]
[null,null,"Amount","Percentage "]
[null,null,"EUR\n","%"]
["Expected Sources of Funding"]
[]
["EU/EDF contribution sought in this application (A)",null,{"v":200000,"d":"200,000"}]
[]
["Other contributions (other Donors etc)"]
["Name","Conditions"]
[null,null,{"v":5741944,"d":"5,741,944"}]
["SDC",null,{"v":412410,"d":"412,410"}]
["DFID",null,{"v":346375,"d":"346,375"}]
["Korea",null,{"v":28569,"d":"28,569"}]
["Finland",null,{"v":223020,"d":"223,020"}]
["Ireland",null,{"v":40525,"d":"40,525"}]
["USAID",null,{"v":625500,"d":"625,500"}]
["Ntherlands",null,{"v":500000,"d":"500,000"}]
["Mexico",null,{"v":161400,"d":"161,400"}]
["Japan",null,{"v":260745,"d":"260,745"}]
["UNDP-OECD Joint Support Team",null,{"v":3143400,"d":"3,143,400"}]
[]
[]
["Revenue from the Action ",null,0]
[]
["To be inserted if applicable and allowed by the guidelines: "]
["In-kind contribution",null,0]
[]
["Expected Total contributions ( required funding)",null,{"v":5741944,"d":"5,741,944"}]
[]
["Estimated Total Costs (B)",null,{"v":5941944,"d":"5,941,944"}]
["EU/EDF contribution expressed as a prcentage of total costs (A/Bx 100)",null,null,{"v":0.033659017991418294,"d":"3.4%"}]

{"sheet":"Summary of Est. Costs","index":2,"n_rows":50,"n_cols":4,"rows_kept":50,"flags":["formulas_cached_only"]}
["Expected sources of funding & summary of estimated costs"]
[]
[null,null,"Amount","Percentage "]
[null,null,"EUR\n","%"]
["Expected Sources of Funding"]
[]
["EU/EDF contribution sought in this application (A)",null,{"v":200000,"d":"200,000"}]
[]
["Other contributions (other Donors etc)"]
["Name","Conditions"]
[null,null,{"v":9994026,"d":"9,994,026"}]
["Netherlands",null,{"v":870000,"d":"870,000"}]
["Norway",null,{"v":411447,"d":"411,447"}]
["Korea",null,{"v":1080000,"d":"1,080,000"}]
["Mexico",null,{"v":180000,"d":"180,000"}]
["Canada",null,{"v":650628,"d":"650,628"}]
["Austria",null,{"v":168492,"d":"168,492"}]
["Denmark",null,{"v":518794,"d":"518,794"}]
["Finland",null,{"v":500000,"d":"500,000"}]
["Germany",null,{"v":200000,"d":"200,000"}]
["Japan",null,{"v":402313,"d":"402,313"}]
["UK",null,{"v":1599159,"d":"1,599,159"}]
["Switzerland",null,{"v":1009528,"d":"1,009,528"}]
["Italy",null,{"v":50000,"d":"50,000"}]
["Slovak Republic",null,{"v":10000,"d":"10,000"}]
["Ireland",null,{"v":300000,"d":"300,000"}]
["Australia",null,{"v":526265,"d":"526,265"}]
["Spain",null,{"v":54000,"d":"54,000"}]
["France",null,{"v":117000,"d":"117,000"}]
["United States",null,{"v":1346400,"d":"1,346,400"}]
[]
[]
["Revenue from the Action ",null,0]
[]
["To be inserted if applicable and allowed by the guidelines: "]
["In-kind contribution",null,0]
[]
["Expected Total contributions ( required funding)",null,{"v":10194026,"d":"10,194,026"}]
[]
["Estimated Total Costs (B)",null,{"v":10194026,"d":"10,194,026"}]
["EU/EDF contribution expressed as a prcentage of total costs (A/Bx 100)",null,null,{"v":0.019619333911842094,"d":"2.0%"}]
[]
[]
[]
[]
[]
[]
[null,"Signed"]
[]
[null,"______________________________"]